UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6RT8VgU29VdA8UBIgTwUQgKeX2oDBhjPBl/n0JWGHyM='
WHERE
key_id = 'ae43fcc3ecf41591d02e1df3f7cbf0fcc11e506049cac27852ad04672dc2671f'
AND (
token = '6RT8VgU29VdA8UBIgTwUQgKeX2oDBhjPBl/n0JWGHyM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)