UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CSfprqGNh4WiIlA8hxWSzZQ1gDq8mcaIE/gHRJDtScs='
WHERE
key_id = 'c79d851fd46b598158b857efaa26fa08c73fc871c579e058fbef0f5565b1e0df'
AND (
token = 'CSfprqGNh4WiIlA8hxWSzZQ1gDq8mcaIE/gHRJDtScs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)