UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sK9R8nmBrLXbsNK95rhPiCJYgDPPTjoXaXhHmNk7+wA='
WHERE
key_id = '148a5f1c58d67f5a51a4c9ca91f0b5d601db9724dbf9ad9231a7b9507f91b376'
AND (
token = 'sK9R8nmBrLXbsNK95rhPiCJYgDPPTjoXaXhHmNk7+wA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)