UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZpaRbIXdyMN/h77EU3FKSUPBYeslIKqCGNNbF8qGZHs='
WHERE
key_id = '7f992defc082d0fc3bb75a26dc0b36b5e146e7a5722250ce0228840e328f9caa'
AND (
token = 'ZpaRbIXdyMN/h77EU3FKSUPBYeslIKqCGNNbF8qGZHs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)