UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YHvHqHVthovnuYQ23Rk9y/kVDZnuJ2y2weSkR+fs0tc='
WHERE
key_id = '4c65acabd2f1419b4ab5595ac3f95d99641800b62446c85236de2c538f273149'
AND (
token = 'YHvHqHVthovnuYQ23Rk9y/kVDZnuJ2y2weSkR+fs0tc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)