UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tTq95tX+7bVYAB6TYwU7oLTDB+K/DdT3zWxm9FC9gcM='
WHERE
key_id = '76bc7d08bc188d4e55f52b95a77b77771659d4a3053717d23d953de4e8ad3b28'
AND (
token = 'tTq95tX+7bVYAB6TYwU7oLTDB+K/DdT3zWxm9FC9gcM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)