UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JaW9OuZOEsaU/yvwCOmGqgh71DuLPY3nErQ8JPYwpAA='
WHERE
key_id = '42e6b0517f6e1235b223f5dcd825672c85b0e0c108aea24a4d0bc19ea8a4266e'
AND (
token = 'JaW9OuZOEsaU/yvwCOmGqgh71DuLPY3nErQ8JPYwpAA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)