UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xGJSwRVIX0+PUl5MblgF/nGfs/yOoHX7ZYFMmTZ4KnI='
WHERE
key_id = 'dd9e7d4c67b43ae9ee9fba38a4e958b22fbd6512164757476f4df1e2e20a0cc2'
AND (
token = 'xGJSwRVIX0+PUl5MblgF/nGfs/yOoHX7ZYFMmTZ4KnI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)