UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+bh1n2gqynKLN1LKhxhOFQuL3KhahQ7z+dcM40pbnZc='
WHERE
key_id = '78ea00b79cc6facec20cd0ca6091cf2185fefc142f65edead16717aebfc57d2c'
AND (
token = '+bh1n2gqynKLN1LKhxhOFQuL3KhahQ7z+dcM40pbnZc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)