UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TXoWlQ/h7RDnkbfoshaM51V4JWnzW0i4RuEF82RcTts='
WHERE
key_id = '1a1dc268790d9955f84460a15af419478212d60073e40274323e39321fc9bbc1'
AND (
token = 'TXoWlQ/h7RDnkbfoshaM51V4JWnzW0i4RuEF82RcTts='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)