UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CSVQJMWzUUmCh1aBuMvKzxvTLeBZd9F2siEjAB4CV08='
WHERE
key_id = '6f00b8e53aca0af90e5b507dd2f2bc6c3edb85a0af7d3c20dc4670e5cac9e8a8'
AND (
token = 'CSVQJMWzUUmCh1aBuMvKzxvTLeBZd9F2siEjAB4CV08='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)