UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iPWSTqQWUTjaT4JWG8zJWEIXsjtm0rnzkuzjyZ11Ggc='
WHERE
key_id = '8db4830e4eb465534434f07fb59c2a6fd699ab60ad707b32d7432e6ff687b39b'
AND (
token = 'iPWSTqQWUTjaT4JWG8zJWEIXsjtm0rnzkuzjyZ11Ggc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)