UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hY0IsWEIK4Un5hPZf7DpePBzy3arfjLlyY/UFniXKMs='
WHERE
key_id = 'f0c183ee5a21e6e93e50a8cfa9ae6f79e14c5935fa0848d4d3165088e0470641'
AND (
token = 'hY0IsWEIK4Un5hPZf7DpePBzy3arfjLlyY/UFniXKMs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)