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