UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xxtr+z75t5QEYLwag6fKSe9LWdj94M7aeniyqw97rno='
WHERE
key_id = '59724c6c1cb8aaabd499f049f3eb332648e1727bc9dabf0a000dcd3eab45ff47'
AND (
token = 'Xxtr+z75t5QEYLwag6fKSe9LWdj94M7aeniyqw97rno='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)