UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YW/BtFi2+bENz5Tm7A+BZ9WuuFWwU48SlHoHFgXGZNU='
WHERE
key_id = '9537a1e78c5bbc3e74ba8bb8b67c994bda03a0f4d416e6daef4312ddf6710aef'
AND (
token = 'YW/BtFi2+bENz5Tm7A+BZ9WuuFWwU48SlHoHFgXGZNU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)