UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lXm41HHeKRJoreKp+Gm5wBKYryENsWVFuJymzqgFIvM='
WHERE
key_id = 'ae9df682770f0cf96af5233da622b9105806c2368d32373dc6efdc0ffa66f53f'
AND (
token = 'lXm41HHeKRJoreKp+Gm5wBKYryENsWVFuJymzqgFIvM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)