UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HvbgZ1XmX56x9fpkcBMnBvaZgMn+UdA7FZlAUBQq3Bo='
WHERE
key_id = '9c4c18dccb4c1764c523cf91b1c929e1820bd69c0d7112a6ac74031b5afedaf2'
AND (
token = 'HvbgZ1XmX56x9fpkcBMnBvaZgMn+UdA7FZlAUBQq3Bo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)