UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e3f0tU9Twq09/P7foEgdRylGbqh60PDfP9irHZ0oHhA='
WHERE
key_id = 'd9b10f4df27147a688ef367548f17d5b1c6d1ab7222c9689e117a99d0aff7355'
AND (
token = 'e3f0tU9Twq09/P7foEgdRylGbqh60PDfP9irHZ0oHhA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)