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