UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dgHQJbXuIKkIa0b0wEVjVJJmZRwr46/TFW9GvjiPBvs='
WHERE
key_id = 'ce107c6b8d0c6be7c730ea4e51248269bb247f298b1f4b9328ad157c7dbb850c'
AND (
token = 'dgHQJbXuIKkIa0b0wEVjVJJmZRwr46/TFW9GvjiPBvs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)