UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nIdiLqaoR5X0sPv6Wua0C03bXCTh/aNNMUDfrMwSjuo='
WHERE
key_id = 'e142801c7d0c94ab9ffdedbe0104a04e8c6c331500592dcec33085bdb410fbec'
AND (
token = 'nIdiLqaoR5X0sPv6Wua0C03bXCTh/aNNMUDfrMwSjuo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)