UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XicfQXrOA0gawoNlv67VT9z7a9Wp197PzoJ9llnoJdY='
WHERE
key_id = '80ec3699ba270328cb969bafd3dd8d3eff861a3d86d85e73aae4021be4871acc'
AND (
token = 'XicfQXrOA0gawoNlv67VT9z7a9Wp197PzoJ9llnoJdY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)