UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JHOSadKSY5TRW49i6YwW40vYxzBV8j59zWEWEwigCDE='
WHERE
key_id = '2903d939986d90d5b81f29bed89927ef4eeaac871913b4d1cbc726d2aefc11ca'
AND (
token = 'JHOSadKSY5TRW49i6YwW40vYxzBV8j59zWEWEwigCDE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)