UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TBNGATH+eSyAxp8yZMqQ+Sb5ucIozWWJwuW1dO/sSuc='
WHERE
key_id = '591927f2ed34687e281a8735053650351bc7d22a35fb4c3b08d8017e4b243c4e'
AND (
token = 'TBNGATH+eSyAxp8yZMqQ+Sb5ucIozWWJwuW1dO/sSuc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)