UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'j71L3L54OUkjflnpG8Dh1C1iOVjIHf1uk2scydu5huI='
WHERE
key_id = 'bf611d96b27be6e098fde036ffdf176bbe5a455c189b0d18c207a8f0a15d4653'
AND (
token = 'j71L3L54OUkjflnpG8Dh1C1iOVjIHf1uk2scydu5huI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)