UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xQW584bWmcR5JYBTBVaymuC3RJ26KjWfzqbhvOeaP4M='
WHERE
key_id = 'c3f7a76a3598c9fb14b11108f215f20727de3f77c8b9c3d44514bc75e9bc5257'
AND (
token = 'xQW584bWmcR5JYBTBVaymuC3RJ26KjWfzqbhvOeaP4M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)