UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/biqL39fVrz8YxH0T9/Zut0+9qmC987EoatycqC5+uE='
WHERE
key_id = '6d34a11a421dc6aac639fda478a1ff19369f87c99d66da51063be4abb125e44e'
AND (
token = '/biqL39fVrz8YxH0T9/Zut0+9qmC987EoatycqC5+uE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)