UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G8M4zX2IX9GLsv0X8jrC2rldyZRbeW04WSSgYI3jMGU='
WHERE
key_id = 'c7388b1100933e4e1b029b523279c36780e52511022b3e311a2a1a0368e2e6fe'
AND (
token = 'G8M4zX2IX9GLsv0X8jrC2rldyZRbeW04WSSgYI3jMGU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)