UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a8uQn5EDX0ALMyR3xmtdcyNNB2bFljmCE0s5NhY3x34='
WHERE
key_id = '827d711d78b48fa7b901bd41fe0e119917f21c0ef6f99d0ecf2e1e6c6ac2aac9'
AND (
token = 'a8uQn5EDX0ALMyR3xmtdcyNNB2bFljmCE0s5NhY3x34='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)